package mr.ali.webvideo.mapper;

import mr.ali.webvideo.model.CollectionUrl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
* <p>
    *  Mapper 接口
    * </p>
*
* @author Mr-ali
* @since 2025-08-16
*/
    @Repository
    public interface CollectionUrlMapper extends BaseMapper<CollectionUrl> {
    /**
     * 剧集的已发布的计数*/
    @Select("select COUNT(*) from collection_url where video_id = #{videoId}")
    Integer CountByUrlVideoId(Integer videoId);
    }
